IF EXISTS (SELECT * FROM sysobjects WHERE type = 'P' AND name = 'UserUpdateByUserID')
	BEGIN
		DROP  Procedure  UserUpdateByUserID
	END

GO

CREATE Procedure UserUpdateByUserID
(
	@UserID int
	, @UserName varchar(20)
	, @Password varchar(16)
	, @FullName varchar(60)
	, @UserType bit
)
AS

UPDATE Users
SET UserName = @UserName
	, Password = @Password
	, FullName = @FullName
	, UserType = @UserType
WHERE UserID = @UserID
